Skip to main content

❌ Delete Record

The Delete Record action allows you to remove existing records from a database table based on specified filter criteria.

Configuration​

  • Name: Enter a descriptive name for the delete record action.
  • Select Source: Choose the data source or connection from which the records will be deleted.
  • Select Schema: Specify the database schema containing the target table.
  • Select Table: Choose the table from which records will be deleted.
  • Select Column: Define one or more columns and their corresponding values to target specific records for deletion. For each column:
    • Select the column name.
    • Enter the value or use an expression (fx) to dynamically specify it.
    • Use the plus (+) button to add more columns or the trash icon to remove.
  • Filter: Apply filter conditions to narrow down which records are deleted.
    • Use the Select Filter button to add filtering criteria.
    • Add or remove filters using the plus (+) and delete (x) buttons.

Features​

  • Deletes specific records based on multiple column values.
  • Supports dynamic value assignment using expressions.
  • Allows precise targeting with complex filters.
  • Integrates with various data sources and schemas.

Use Cases​

  • Remove obsolete or invalid user accounts.
  • Delete expired or canceled orders.
  • Clean up test or temporary data automatically.
  • Implement data retention policies in workflows.

Notes​

  • Use filters carefully to avoid accidental deletion of unintended records.
  • Ensure the source, schema, and table exist and are accessible.
  • Test delete actions in non-production environments first.

Tip: Combine Delete Record with Get Record and Filter array actions to manage data cleanup workflows safely.